UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yRVV28fmPg+9pYpWrV65lXAURU4gj2u+/tcIcrOq6gw='
WHERE
key_id = '323da41a9dd02b4211ee7fefce98e23ab8f1d5f82e3f34816777e3d4af23b335'
AND (
token = 'yRVV28fmPg+9pYpWrV65lXAURU4gj2u+/tcIcrOq6gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)