UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sx+HZy6H3N0eJ/EtXUKpTbhhxMVTfsSKSo05498U7Bk='
WHERE
key_id = 'f407eb7bad0c0851b57be5ef2eef1f22ba571c8c286216f8022373aac147d518'
AND (
token = 'sx+HZy6H3N0eJ/EtXUKpTbhhxMVTfsSKSo05498U7Bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)