UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQgnTNeiTLQHAgW4/dfmdQgv4TYLZevlL1MoY4FkmUk='
WHERE
key_id = 'e50a6bf852626fa73e4c1e7e7c21410f240c4b42d0318288507ffb661898b8c6'
AND (
token = 'lQgnTNeiTLQHAgW4/dfmdQgv4TYLZevlL1MoY4FkmUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)