UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7pFdNJuW9iWnFsobF370B3G1wn7e4kpyChyOD+1A+Vg='
WHERE
key_id = '59baa2cdcb1e122a5e79a47ecb4f9cf2d1cea460f037ba088126bed597a1789f'
AND (
token = '7pFdNJuW9iWnFsobF370B3G1wn7e4kpyChyOD+1A+Vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)