UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1wEyUJLfJV4GxPU3m6tjpR3IG3kLs/c5guCfrQyAzLU='
WHERE
key_id = '31f3069a8dc6183fbe820c2b10215eca11b852714a3e1b193e65c8a994d9cd5b'
AND (
token = '1wEyUJLfJV4GxPU3m6tjpR3IG3kLs/c5guCfrQyAzLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)