UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mkc1iHuwPbWr5f7bWfJCpPuB6JWMnEHw1zcJQ2wCzM='
WHERE
key_id = '51689a78046f7d2c891530310cf5769c6c464999b74fa2e6b2f942871511c63f'
AND (
token = '8mkc1iHuwPbWr5f7bWfJCpPuB6JWMnEHw1zcJQ2wCzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)