UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xbS52ChwM8aLldkZ3o12ReMk6PWRqOKEhAYtHGOL9Ek='
WHERE
key_id = '0c13e810a11203528848e4ba49d5116e581242626fd2995673634af0843ec017'
AND (
token = 'xbS52ChwM8aLldkZ3o12ReMk6PWRqOKEhAYtHGOL9Ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)