UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzD+h4zAActiCAK0scoAfMaI/KZSWzWfVvCmO56wmdw='
WHERE
key_id = 'c1148757a854dad79f92bc7cba0f08f1d95b99679e7b962d751bd37c01f12789'
AND (
token = 'KzD+h4zAActiCAK0scoAfMaI/KZSWzWfVvCmO56wmdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)