UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tDeVPSgAvMqL5OpEVmIxQm1Wm1LhSRs/j5bejSL7mZA='
WHERE
key_id = 'b6f1fe5687a84bf8823034d303414934f5e8e8f10e8e096068a25542c40ef2e8'
AND (
token = 'tDeVPSgAvMqL5OpEVmIxQm1Wm1LhSRs/j5bejSL7mZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)