UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqEJhd5kORdCHEPXZ3wsliCU13X6n5E9NNa7SZx32GI='
WHERE
key_id = '1cdc6eac182fde21006c7b33d5a4ad31f39c2ba56cdb1fc86c69080be114c0ac'
AND (
token = 'pqEJhd5kORdCHEPXZ3wsliCU13X6n5E9NNa7SZx32GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)