UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dOb82x3EsYEeEVgnnyS/GGu5LWXZKOWWA20FdtRoj9A='
WHERE
key_id = '167e52bdcee257d4e6bdff853f95a98d87d28568b5495bcfc7ef57d27e3ad6fd'
AND (
token = 'dOb82x3EsYEeEVgnnyS/GGu5LWXZKOWWA20FdtRoj9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)