UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6iD1PrI8CWeQsf78ROFkr+gQkBd14obAesDQp36gF8='
WHERE
key_id = 'd127b4bf7965131b68077efd2e3ff6768080f726616a3f46b1682f0c67d4bfe4'
AND (
token = 'p6iD1PrI8CWeQsf78ROFkr+gQkBd14obAesDQp36gF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)