UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HP1JKZhkdkRcIOppWxE7vnl2eXKCaXgE6+OUMW3C74='
WHERE
key_id = 'b1858eb20dc468b154fe9b2371f88b4d4660651ef197087d60c905e80b7268ff'
AND (
token = '8HP1JKZhkdkRcIOppWxE7vnl2eXKCaXgE6+OUMW3C74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)