UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u39PDb8t0/Qb0otEgV2wGOaWsxIkMzACshS3iv4EN/M='
WHERE
key_id = '4b27248724e7445875264eafeebd1c149ea6ebe395cc3300f8a05c4559a60a90'
AND (
token = 'u39PDb8t0/Qb0otEgV2wGOaWsxIkMzACshS3iv4EN/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)