UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7wc8K8ZAclGxKmOeoe3bCSZ9qjdQHYD2m3lk2kQzKS8='
WHERE
key_id = '0914fecd28bd962fd66e354a29b27a795336404227bf9af29aa0df08b880226d'
AND (
token = '7wc8K8ZAclGxKmOeoe3bCSZ9qjdQHYD2m3lk2kQzKS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)