UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJAneO3/5cUs9hMXuGX0Is4+usmgv/BzFs6LCv4cCmw='
WHERE
key_id = '0f904acec6d2e0344b8a720abd899b997f91a66337e4831f2d96cdfaf5b378e2'
AND (
token = 'gJAneO3/5cUs9hMXuGX0Is4+usmgv/BzFs6LCv4cCmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)