UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsBk/o3Lb5fcUsuXZQ7vSm8GkJO7tjH959Cw0iE1sRs='
WHERE
key_id = 'b9774704394b4a7318bd33c40db783bac8c99eb098f7903533e028bdc6e90a31'
AND (
token = 'bsBk/o3Lb5fcUsuXZQ7vSm8GkJO7tjH959Cw0iE1sRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)