UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iUi9E7HqRSmlwUEgEwp/8xVc/AGk+ofdRpWd8LZptrM='
WHERE
key_id = 'cdab0427dd78cf7a37e92298b9332bbddf966e9bb870d4c6cefe3fd8fd92790f'
AND (
token = 'iUi9E7HqRSmlwUEgEwp/8xVc/AGk+ofdRpWd8LZptrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)