UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oNP2WMouw0d6JYcds3crZ5sAj8HuIas5fL0qm4ik5Lk='
WHERE
key_id = '2ff6878cf8c07a946d65307575156a45bf86bd5d9b3afc3ad8f010c05082f941'
AND (
token = 'oNP2WMouw0d6JYcds3crZ5sAj8HuIas5fL0qm4ik5Lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)