UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHy53aZWHoCu50Im+7Ua2iJcueEkgFtRkaUFy1iFHsw='
WHERE
key_id = '3c790d7012ffc82e9f4d396cdb1e10cc31d0be929ff00e7ee62edcbd88662e70'
AND (
token = 'BHy53aZWHoCu50Im+7Ua2iJcueEkgFtRkaUFy1iFHsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)