UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LgbnHm8mgwa7/US3nCXJSiSrccSbZp/76LPFGw99mlA='
WHERE
key_id = '165fc3f3773c9a5e9a4632c5b53097a781df6c69ba1a933581cf9900ffaf9baf'
AND (
token = 'LgbnHm8mgwa7/US3nCXJSiSrccSbZp/76LPFGw99mlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)