UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQCg/XeogkhF4P1dJ5LI3k7wb44mkGddWFS5XPzXdOM='
WHERE
key_id = '0525439d774622bfa9aca75a2320485d0872b05307b0196dc4d12593869bb7bc'
AND (
token = 'lQCg/XeogkhF4P1dJ5LI3k7wb44mkGddWFS5XPzXdOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)