UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'psxUURDaXy+eMK4gGpES1dTYx5cDvWMUlkCPdhzJuTo='
WHERE
key_id = '9b24cc1cb0af6471b53a2e1095dc2b2ab2caca8a0a7a8d31a4f353e0a5cfcba7'
AND (
token = 'psxUURDaXy+eMK4gGpES1dTYx5cDvWMUlkCPdhzJuTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)