UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aCTWjB3NQBUH5HSoJ77uiKkncK9CIEyrSlW0SSBCYCE='
WHERE
key_id = 'e692cc9c06d321eecc07a16cc66d3bef3a5aaf67ff38f852b9b9783481213a8c'
AND (
token = 'aCTWjB3NQBUH5HSoJ77uiKkncK9CIEyrSlW0SSBCYCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)