UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YBzOGd7aXAbMTRBbxuoBIExFtC6tKg11heEUJeaTmCs='
WHERE
key_id = '6e87afc36be7e2ac1d76c38cc2dc94393b8c1792d201fcea72d237a7287b7b1f'
AND (
token = 'YBzOGd7aXAbMTRBbxuoBIExFtC6tKg11heEUJeaTmCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)