UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RG5J6ZteGBMtQVByzFiSMHpOK4b24LUZ1++x0vYYVpw='
WHERE
key_id = '9dcfc5237f6df8d4256ec695c575136452c179c777fe8a43b800154cee4b9cfc'
AND (
token = 'RG5J6ZteGBMtQVByzFiSMHpOK4b24LUZ1++x0vYYVpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)