UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BU5RVSr0q5cLVYLpC26HyK69nYMK+USukW2jtUlCsH8='
WHERE
key_id = '574bb870d7720e056605f00b2f78ac7a76343d0b6ca0a7b3d9cd970b0c70bc3a'
AND (
token = 'BU5RVSr0q5cLVYLpC26HyK69nYMK+USukW2jtUlCsH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)