UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j7ep956D9xfteTa12ObdvkCCTujIB0o2FozXsMBfWR0='
WHERE
key_id = '8ebd1a727a801d50e873b62a76dfe73bb1cff545c67ee6f50df5c8636fbb191e'
AND (
token = 'j7ep956D9xfteTa12ObdvkCCTujIB0o2FozXsMBfWR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)