UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLdvE5NPT2luC+qDSy5WhRgEGnmworTmd2GHikgZX2I='
WHERE
key_id = '788641033d2093419a9e907836c23fe50dd77690b8a47f9df3fc652eaae350fe'
AND (
token = 'ZLdvE5NPT2luC+qDSy5WhRgEGnmworTmd2GHikgZX2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)