UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vENnE6VmvLwJPMtsKwlqtAU2JggpU4o7oOKDChl6ufw='
WHERE
key_id = 'c9c5c82efa251aea568463b26e5f9b123095f380e44944a6477749f338433558'
AND (
token = 'vENnE6VmvLwJPMtsKwlqtAU2JggpU4o7oOKDChl6ufw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)