UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3baIUeR/m1xRxj2xEsNZJeyS5FsbduhwS2/acF8nMbI='
WHERE
key_id = '9bbaadfb0651d2420f949b0bd69f7d1074f07838ceef2c7645f347c6fd04e7f8'
AND (
token = '3baIUeR/m1xRxj2xEsNZJeyS5FsbduhwS2/acF8nMbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)