UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZ1g4NLKXwrbfCpP3mYORMVkAMR/W9UOrWLh9Fu3uVk='
WHERE
key_id = 'bb826fac2d7b66e9f4bb085b6fe5420eca1d03b9795cf812acd36049f571d3d9'
AND (
token = 'vZ1g4NLKXwrbfCpP3mYORMVkAMR/W9UOrWLh9Fu3uVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)