UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pt3JBE6+9o+yrQmQeiv08+HvmvNQk4C+25/GX7K8veM='
WHERE
key_id = '415852b8c9bfeba76d1efbd8b1819e535798deb8ed48b751bde2dae8c652162e'
AND (
token = 'pt3JBE6+9o+yrQmQeiv08+HvmvNQk4C+25/GX7K8veM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)