UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oYgx88vygX64FChnPBjnU1y9ckWOyQaAwGHQyREmiKo='
WHERE
key_id = 'f0dca8e581c174f1afc9241d81674efc2f0213e98dd104bbbecd042f07ac7f36'
AND (
token = 'oYgx88vygX64FChnPBjnU1y9ckWOyQaAwGHQyREmiKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)