UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7eCJqKZ/YaCU0HSt0OUi6tNAgirM11rftbBuVEO/b8='
WHERE
key_id = '684a88b85dc4e4f013e97344f97cbdd8246d0363ef8cb3f1d7d9693f906acb2f'
AND (
token = 'U7eCJqKZ/YaCU0HSt0OUi6tNAgirM11rftbBuVEO/b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)